Multidatabase Querying by Context

نویسندگان

  • Ramon Lawrence
  • Ken Barker
چکیده

The overwhelming acceptance of the SQL standard [10] has curtailed continuing research work in relational database query languages and processing. Since all commercial relational database systems conform with the SQL standard, there is little motivation for developing new query languages. Despite its benefits and wide-spread acceptance, SQL is not a perfect query language. Complex database schema challenge even experienced database users during query formulation. As increasing numbers of less sophisticated users access numerous data sources within an organization or across the Internet, their ability to accurately construct queries with the appropriate structure and semantics diminishes. SQL can be hard to use as it provides only physical access transparency not logical transparency. That is, a user is responsible for mapping the semantics of their query to the semantics and structure of the database. Although graphical tools for query construction and high-level programming languages mask some of the complexity, the notion of querying by structure is intrinsic to most forms of data access. In this work, we overview a new query language developed in conjunction with our integration architecture for automatically integrating relational schema. Although the major focus of this work is on database interoperability, the contribution of this paper is a language for specifying queries on the integrated view produced. The complexities of querying across database systems and resolving conflicts are too numerous to be fully described here, so this paper will discuss querying the integrated view of a

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Opm*qs: the Object-protocol Model Multidatabase Query System Acknowledgements We W Ant to Thank Chris Fields and Carol Harger from the National Center for Genome Resources

We describe in this document the OPM multidatabase query system OPM QS that allows querying multiple databases that have an OPM interface using the OPM multidatabase query language OPM QL OPM is a data model that allows specifying database schemas in terms of objects and protocols laboratory experiments The OPM query language OPM QL allows querying databases that have been developed using the O...

متن کامل

A Query Language and Interface for Integrated Media and Alphanumeric Database Systems

In this paper we consider a multidatabase system which con sists of media databases and traditional alphanumeric databases The semantic relationships which may exist among the objects in the me dia databases and alphanumeric databases are introduced By applying the semantic relationships the related information in the system can be integrated Therefore more powerful querying capabilities and a ...

متن کامل

Limiting Result Cardinalities for Multidatabase Queries Using Histograms

Integrating, cleaning and analyzing data from heterogeneous sources is often complicated by the large amounts of data and its physical distribution which can result in poor query response time. One approach to speed up the processing is to reduce the cardinality of results – either by querying only the first tuples or by obtaining a sample for further processing. In this paper we address the pr...

متن کامل

Concurrency Control in the Deomain of Multidatabase: A Semi-semantic Approach

Multidatabase is a promising approach to achieving interoperability among various DBMSs. The latest development in distributed object management techniques enlarges the scope of multidatabase system. This paper explores the trade-o between the concurrency achieved and the extra overhead incurred by the semantic-based concurrency control. It proposes a semisemantic approach to rationalize the co...

متن کامل

InterBase-KB: Integrating a Knowledge Base System with a Multidatabase System for Data Warehousing

This paper describes the integration of a multidatabase system and a knowledge-base system to support the data-integration component of a Data Warehouse. The multidatabase system integrates various component databases with a common query language, however it does not provide capability for schema integration and other utilities necessary for Data Warehousing. The knowledge base system offers in...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 2000